List<!field#>Game Date Formats<!field#><!field#>0<!field#>SELECT g.GameDate AS 'SQL Date', CASE WHEN strftime('%m', g.GameDate) < '10' THEN substr(strftime('%m', g.GameDate),-1,1) ELSE strftime('%m', g.GameDate) END
 AS Month, CASE WHEN strftime('%d', g.GameDate) < '10' THEN substr(strftime('%d', g.GameDate),-1,1) ELSE strftime('%d', g.GameDate) END AS Day, substr(strftime('%Y', g.GameDate),-2,2) AS Year, CASE WHEN strftime('%m', g.GameDate) < '10' THEN substr(strftime('%m', g.GameDate),-1,1) ELSE strftime('%m', g.GameDate) END || "/" || CASE WHEN strftime('%d', g.GameDate) < '10' THEN substr(strftime('%d', g.GameDate),-1,1) ELSE strftime('%d', g.GameDate) END || "/" || substr(strftime('%Y', g.GameDate),-2,2) AS 'm/d/yy', strftime('%m/%d/%Y', g.GameDate) AS 'mm/dd/yyyy', CASE WHEN strftime('%m', g.GameDate) < '10' THEN substr(strftime('%m', g.GameDate),-1,1) ELSE strftime('%m', g.GameDate) END || "-" || CASE WHEN strftime('%d', g.GameDate) < '10' THEN substr(strftime('%d', g.GameDate),-1,1) ELSE strftime('%d', g.GameDate) END || "-" || substr(strftime('%Y', g.GameDate),-2,2) AS 'm-d-yy', strftime('%m-%d-%Y', g.GameDate) AS 'mm-dd-yyyy' FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  GROUP BY g.ID<!field#>false<!field#>0<!field#>1<!field#>1<!field#>0<!line#>ListField<!field#>22<!field#>g.GameDate<!field#>SQL Date<!field#>2<!field#>1<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>22<!field#>CASE WHEN strftime('%m', g.GameDate) < '10' THEN substr(strftime('%m', g.GameDate),-1,1) ELSE strftime('%m', g.GameDate) END
<!field#>Month<!field#>2<!field#>2<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>22<!field#>CASE WHEN strftime('%d', g.GameDate) < '10' THEN substr(strftime('%d', g.GameDate),-1,1) ELSE strftime('%d', g.GameDate) END<!field#>Day<!field#>2<!field#>3<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>22<!field#>substr(strftime('%Y', g.GameDate),-2,2)<!field#>Year<!field#>2<!field#>4<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>22<!field#>CASE WHEN strftime('%m', g.GameDate) < '10' THEN substr(strftime('%m', g.GameDate),-1,1) ELSE strftime('%m', g.GameDate) END || "/" || CASE WHEN strftime('%d', g.GameDate) < '10' THEN substr(strftime('%d', g.GameDate),-1,1) ELSE strftime('%d', g.GameDate) END || "/" || substr(strftime('%Y', g.GameDate),-2,2)<!field#>m/d/yy<!field#>2<!field#>5<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>22<!field#>strftime('%m/%d/%Y', g.GameDate)<!field#>mm/dd/yyyy<!field#>2<!field#>6<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>22<!field#>CASE WHEN strftime('%m', g.GameDate) < '10' THEN substr(strftime('%m', g.GameDate),-1,1) ELSE strftime('%m', g.GameDate) END || "-" || CASE WHEN strftime('%d', g.GameDate) < '10' THEN substr(strftime('%d', g.GameDate),-1,1) ELSE strftime('%d', g.GameDate) END || "-" || substr(strftime('%Y', g.GameDate),-2,2)<!field#>m-d-yy<!field#>2<!field#>7<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>22<!field#>strftime('%m-%d-%Y', g.GameDate)<!field#>mm-dd-yyyy<!field#>2<!field#>8<!field#>true<!field#>1*<!field#><!report#>